﻿IF object_id(N'dbo.TabExtMailList', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[TabExtMailList] (
        [MailID]      nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
        [Username]    nvarchar(20)  COLLATE Chinese_PRC_CI_AS NULL,
        [Email]       nvarchar(128) COLLATE Chinese_PRC_CI_AS NULL,
        [ReadFlag]    bit           NULL,
        [FolderID]    int           NULL,
        [HeadersText] nvarchar(max)  COLLATE Chinese_PRC_CI_AS NULL,
        [Subject]     nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [TextContent] nvarchar(max)  COLLATE Chinese_PRC_CI_AS NULL,
        [HtmlContent] nvarchar(max)  COLLATE Chinese_PRC_CI_AS NULL,
        [FromName]    nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [FromEmail]   nvarchar(128)  COLLATE Chinese_PRC_CI_AS NULL,
        [CcTo]        nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [BccTo]       nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [Replyto]     nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [SendDate]    datetime      NULL,
        [BodySize]    nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [Size]        int           NULL
    );
END
GO
